SD - Surya-Venkat-Adithya - 2016-04-12 - 26547 - Spec - ZHOT Transaction Changes (Rizwan by 2016-05-15) #SDSupportReports #SDMiscellaneousReports

SPECIFICATIONS

26547 -Spec - Include Drop ship orders in ZHOT Report


Purpose

Include drop ship orders in ZHOT report

Admin Info

Purpose
 Include drop ship orders in ZHOT report
Requested By
 Jeffrey Mau
Spec Created By
 Surya, Adithya
Spec Created Date
 04/12/2016
Spec QA by
 Surya Basa
Objects
 ZSD_HOTMARKET_REPORT
Document Status
 Completed

Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 04
2
 Documentation
 08
3
 Development/ Config
 60
4
 Unit test in DEV
 40
5
 Unit test in QUA
 40
6
 Other activity
 N/A

TOTAL
 152
References
Pior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]

2014-12-09 - XXXXX - Spec - Include Drop ship Orders in ZHOT Report-(Jeff)

Documents

[Attach any document(s) received for the requirement(s)]

NA

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any
1
 Add option to filter open orders only in the selection
 Rizwan Shah
 2016/06/16
2
 Add new fields to the output -
a) Item Category (next to sales document)
b) Customer ID partner - next to sold-to description
(KNA1-J_3ASTCU)
 Rizwan Shah
 2016/06/17
3
 The "open Sales orders/Contracts" check box in transaction ZSORD should be checked by default
 Rizwan Shah
 2016/07/06
4
 Customer ID of SH should be pulled instead of SP from sales order and Place Customer ID beside SH in the report
 Rizwan Shah
 2016/07/14

Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]
To include drop ship orders in ZHOT report - which basically shows open quantities on selected Sales Orders and Contracts.

Add Few fields as input selection for the ZHOT Report:

1. Customer Number (Which can be given as a range and multiple values)
2. Customer PO Number (Which can be given as a range and multiple values)
3. SO Creation Date Range.
4. Sales Representative - Code (Which can be given as a range and multiple values)

Add the Below Fields in the output report:
1. Rejection Code (Next to EAN/UPC)
2. Rejection Code Description
3. Customer UPC
4. Season Description (next to season ID)

Change the T Code from existing ZHOT to ZSORD and the description as, Open Orders Report

In Scope:

[List the activities to be included in scope]
Drop Ship Orders, including SNC and non-SNC, will be included in the report.

Out of Scope:

[Out of scope activities]
NA

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

Modify Report ZHOT to include Drop Ship Orders ( Sales Order with Item Category TAS) in the report.
Add fields Rejection Code, Rejection Code Description,Customer UPC and Season Description in the output report.
Drop ship Sales orders are identified by Item Category TAS. If such a line is not rejected, then the corresponding PO will be identified and open order quantities will be determined from the PO.

Test Plan
[List test scenarios/cases to be executed here]
Originally there were 12 scenarios (ZHOT) to check the validity of the program.

The test plan here is based on the following

Test ID
 Test Scenario
 Expected Results
ZHOT-1
 Create contract with material X for size 700-100EA and a sales order with reference to contract for
10EA respectively
 The open contract and open order qty field against the contract should appear as 90
ZHOT-2
 Create contract with material X for size 700-100EA and two sales orders for 50EA and two deliveries for
50EA
 The delivery qty should appear as 50EA against each of deliveries and the open ord qty should appear as ZERO against both the sales orders
ZHOT-3
 Create contract with material X for size 700-100EA and two sales orders for 50EA and one delivery each
for the sales order for 25EA and;two deliveries one each for the sales order for size 700,718,714-25EA and 700-15,718-10,714-13EA respectively
 The open order qty against the contract should appear as ZERO.
The delivery qty should appear as 25EA against each of deliveries and the open ord qty should appear as 25EA against each of the sales orders respectively.
ZHOT-4
 Create sales order with material X for 100EA against the sizes 612,658,634,678 and;
Create two deliveries with sizes 612-85,658-100EA and 612-15,634-100,678-100EA respectively
 The delivery qty should appear as 100EA against each of the sizes 612,658,634,678
ZHOT-5
 Create Sales Order with material X for size 2XL-10 and reject the item.
 Order qty field should appear as 10, confirmed qty as ZERO, delivery qty as ZERO and open order qty as 10.
ZHOT-6
 Create Sales Order with material X for size 2XL, 3XL and 4XL-10 respectively and reject size 3XL-10; create delivery
for 2XL, 4XL-10 respectively.
 The order qty field should appear as 10,10,10;
Confirmed qty as 10,0,10;
Delivery qty as 10,0,10;
Open order qty as 0,0,0
ZHOT-7
 Create Sales Order with material X for size 2XL, 3XL and 4XL-10 respectively and reject size 2XL-10; create partial delivery for 3XL-5, 4XL-5 respectively.
 The order qty field should appear as 10,10,10;
Confirmed qty as 0,10,10;
Delivery qty as 0,5,5;
Open order qty as 0,5,5
ZHOT-8
 Create a contract with material X for size 700, 718, 714, 738 -10EA respectively and reject sizes 700,718 for 10EA respectively.
 The order qty field should appear as 10,10,10,10;
Confirmed qty as 0,0,10,10;
Delivery qty as 0,0,0,0;
Open order qty as 0,0,10,10
ZHOT-9
 Created SO with sales org 1000 and 0110 plant with no delivery
 The delivery date field is filled from the SO
ZHOT-10
 Created SO with sales org 1000 and plant 0120 with delivery
 The delivery date field is filled from the SO and the last delivery date is filled with delivery number
ZHOT-11
 Created SO with size of two confirmation dates and created multiple deliveries for each confirmation date
 The last delivery date is displayed in the field for two confirmation dates
ZHOT-12
 Execute ZHOT transaction with material as input and download the report to Excel sheet
 The entire report should download without truncating the last characters
TAS-1
 Create one SO each in sales area 1000/10/00 with single material/size for 100EA with document types ZU3P, ZOR,ZPTO and item category TAS
 100 should appear in the open order qty field against each SO.
TAS-2
 Create one SO each in sales area 1000/10/00 with multiple materials/size for 100EA with document types ZU3P, ZOR, ZPTO and item category TAS. MIGO the documents
 The open order quantity field should appear as ZERO for each SO.
TAS-3
 Create one SO each in sales area 1000/10/00 with multiple materials/size for 100EA with document type ZU3P, ZOR, ZPTO and item category TAS. Create inbound deliveries for each document.
 The open order quantity field should appear as ZERO for each SO.
TAS-4
 Create one SO each in sales area 1000/10/00 with multiple materials/size for 100EA with document type ZU3P, ZOR, ZPTO and item category TAS. MIGO on one material completely and leave alone the others.
 The open order quantity field should only show the quantities for the materials that are not MIGOd.
TAS-5
 Create one SO each in sales area 1000/10/00 with multiple materials/size for 100EA with document type ZU3P, ZOR, ZPTO and item category TAS. Create inbound delivery for one material and leave alone the others.
 The open order quantity field should only show the quantities for the materials for which inbound delivery is not created.
TAS-6
 Create one SO each in sales area 1000/10/00 with single material and multiple sizes for 100EA with document type ZU3P, ZOR, ZPTO and item category TAS. Completely reject one line.
 The open order quantity field should only show the quantities for the unrejected lines.
TAS-7
 MIGO the PO for Test ID - TAS-6
 The open order quantity should appear as ZERO
TAS-8
 Repeat TAS-6 and MIGO the PO partially.
 The open order quantity should only show quantities for the lines that are not MIGOd
TAS-9
 Repeat TAS-6 and create one inbound delivery for all the PO lines.
 The open order quantity should appear as ZERO
TAS-10
 Repeat TAS-6 and create multiple inbound deliveries for all PO lines but one.
 The open order quantity should only show the quantity for the line for which Inbound delivery has not been created.
TAS-11
 One SO having multiple PO's and Create inbound delivery for few PO's
 The open order quantity should only show the lines for which MIGO/Inbound Delivery has not completed
TAS-12
 One PO containing multiple SO's and Create inbound delivery for one item
 The open order quantity should only show the lines for which MIGO/Inbound Delivery has not completed
REP-1
 Check report by input the following -
1. Contract only
2. Contract with call offs
3. Contract with call offs partially rejected
4. Contract with call offs with partial deliveries
5. Contract with call offs with complete deliveries
6. SO's containing item categories TAN and TAS
7. SO's Containing Customer UPC.
8. SO's with out Customer UPC.
9. SO's with materials having season
 1. The open order quantity field should show the full quantity of the contract
2. The open order quantity field should show the full quantity of the contract and call offs
3. The open order quantity field should should not show the quantities for rejected lines on the contract/call off
4. The open order quantity field should not show the quantities for which deliveries are created.
5. The open order quantity field should appear as ZERO
6. The open order quantity field should not show the lines for which deliveries are created or MIGO/Inbound delivery completed.
7. The Customer UPC shall be displayed correctly as in the sales order.
8. The Customer UPC field in the report shall show blank.
9. The report shall show the Season code and Season description.
REJ-01
 Create a sales order for 10 EA and reject a schedule line in the sales order.
 ZHOT Report shall show the Rejected quantity with the rejection code and its description.
INP01
 Check the report by input values of the following:
1. Customer Number
2. Customer PO Number
3. SO Creation Date Range
4. Sales representative.
 The report should display the SO's for the particular customer-customer PO number created in the date range and the sales representative on them respectively.
CHG1
 Test "open sales orders/Contracts" by checking the box
 1. Only open lines with quantities > zero should be displayed when the box is checked.
2. All lines should be displayed when the box is not checked
CHG2
 Input a sales document to test item category and customer ID fields to appear on the report
 Item category and Customer ID should be displayed correctly on the report.

Solution Details

[Provide complete technical details for configuration or programming here]

Modify Report ZHOT to include Drop Ship Orders in the report.

- Remove filter to ignore Document Category TAS in the program.
- The Functionality of Normal Orders ( TAN and TAB) and Drop Ship Orders is Different.Normal Orders have Outbound Deliveries but DROP Ship Orders have Inbound deliveries.
-Open Order Quantity for Drop Ship Orders is based on completion of Inbound Delivery OR MIGO of corresponding PO.
- Add fields in the report Rejection Code, Rejection Code Description, Customer UPC and Season description.

Assumptions:
- The SNC PO is not partially delivered, i,e, A particular SO lines in PO are fully confirmed/delivered.
- A contract call off is not created with Item Category 'TAS'.

Issues

[List Issues / Bugs identified in configuration or development]

1. The Excel download push button icon when used shows missing object, 'sap_sm.xls'
2. When the local file push button is used, the open quantity columns appear on the left side of the excel while they appear on the extreme right of the report.